Oracle Database, SQL, Application, Programming Tips

The place to learn and understand about Oracle.

The Oracle contents on this site are Oracle database, Programming, Forms and Oracle Financial.

There is also an Oracle Discussion Forums for Oracle consultants, FAQ, Tips and Tricks, eBook,  Training Videos and CBT.

Oracle Database Forums
Have a Oracle Problems? This is an email discussion group for ORACLE database administrators, and SQL programmer to share information and request assistance from  ORACLE PEERS around the world.   The discussion topics should be focused on ORACLE specific database and SQL related issues.


Oracle Database and SQL forum for 
Oracle DB and SQL Professional

Google
  Webwww.sap-img.com
FREE Oracle Database Tips Download (No special software required to open the file, just MS Windows 95 and above)
Download your FREE ORACLE TIPS Windows Help File
Oracle Database
Day-to-day Problems & Solutions for DBA’s
What is a deadlock and how does oracle handle it?
What is "snapshot too old" error and how to avoid it?
What does 'SNIPED' status in v$session mean?
Database Crashed. Server manager doesn't come up
How to find your log block size?
How To Find Out The Size Of Database
Oracle FAQ
Finding/Changing Oracle SID of A Database
Understand Exactly What a Schema Is
Change Oracle Installation Location on Linux
Processes that Used Too Much CPU Resources
Hindi Format In Oracle Database
Cloning Database From Hot Backup
How Can We Calculate Hit Ratios

Oracle Developer Programming Tips 
Displaying Elapsed Time: The difference between two dates
Using SQL Plus
Explain Plan Tips
PL/SQL coding

Oracle Forms
Oracle Forms 4.5 FAQ
TEXT_IO code to write data to a flat file

Oracle Control Files
Backup and Recovery Tips

Oracle Application
Oracle Application Hints and Tips

Oracle Books and eBook
OCP: Oracle9i Certification Kit

Oracle in a Nutshell

Oracle PL/SQL Programming, Third Edition

....more Oracle Books and eBook

Oracle Training CBT, Video
Computer Based Training on Oracle Database 
Administration, Certification, Application and
Programming

SQL Tips
What is SQL?
Oracle Interview Q& A : SQL
Editing commands at the SQL> prompt
Connecting To Sql Via Command Prompt
Updating multiple fields with an embedded SELECT
Set up for calling external procedures from Pl/SQL
Using Substitution Variables
Passing values back to unix script from sqlplus
Formatting Columns in both Static and Dynamic Reports
How to Save an Image in a SQL Server Database?
Select Entries from Whole Week
Modifying A Column Of A Table
Modify the Primary Key Order
Renaming A Datafile

EBU/Rman & Legato Tips 
Recover database to a different host using legato & EBU
Recover database to a different host using legato & RMAN

 Useful Oracle Questions and Answers in Discussion Forum
Droping Logfile Group Failed
Advantage Between Range Scan & Skip Scan In Oracle
How Can I Copy Data in Another System
Is IMPORT & EXPORT is platform dependent
Error in PL/SQL block of trigger
Using Trigger And Procedure Together
What is PL/SQL tables?
Accessing Oracle Database
About Referential Integrity
Prerequisites to connect oracle with administrator previleges
Problem Running 'ckrorole.sql' in Sqlplus
Need to write one PL/SQL procedure to housekeep a table
Use user defined functions in SQL statements
Update statements in Query
Why this Query Returns null
Query about Data Storage and Retrieval
Finding How Much Data Has Been Filled
Find How Much Time Left For Query Completion
java.sql.SQLException: ORA-12154
Small Select Statement
Oracle Performance On Different Platforms
Creating Dimensions in Oracle 8i
Explain plan and Autotrace on 8i
HP UX 11.0 - Oracle 7.3.4 linking libraries
How to create a DBMS Job?
Fresh Install Done Login Problem
Problems with Password File
Change the Port number after the Installation
Create Oracle Host
Changing Prompt in SQL Plus
Update B with the Help of A
Tuning a Wait Session
Shutting Down Oracle On Windows
Can we Change a Column Name
Securing Database 9i, User rights
Dynamic Table Names and Moving Table
Tablespace Change
Unlimited Tablespace, User Creation
Regarding the Datatype nvarchar
Help regarding database refresh
Reducing Database Fragmentation
Best way to compare two Databases
Database not Opening
Datafiles Efficiency: More Files vs Increase the Size
Oracle Service Consuming Lot of CPU Resource
How to Start the Service Manager
How to init an object type
Shell Script To Dynamically Generate Init.ora File
How much memory is been utilized by the SGA
Unable to Create a New Instance
Unable to locate statement causing error
Deleting all objects from a tablespace
Deleting duplicate rows in the table
How to Drop undo Tablespace
Multiplexing Redo Logs Onto Raid
Function can use Out/Inout Parameter
Miscellaneous Contents
Free Pop-up Stopper for Internet Explorer
SAP Basis, ABAP Programming and Other IMG Stuff
Java Programming Hints and Tips
Unix System Administration Hints and Tips
Motivation and Inspiration Quotes, Stories
Online Home Working Opportunities

All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site www.sap-img.com is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.sap-img.com or the content authors.